SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422040 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422040 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533746,886648,282862,760661,103412,1028686,219168,154836,887616,214057,1009958,132098,844460,755681,390249,135895,886780,93404,280154,672968,353762,106817,430514,688142,109009,354335,181157,13779,285961,924344,206633,276319,314524,794708,1040808,722870,567404,927446,711309,263794,849130,68454,858419,144358,951342,324553,260881,684357,813442,762067,549105,667450,118299,783683,83557,891513,1003993,32543,208622,322305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003881s ]