SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338023 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338023 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38090,773677,25538,927244,903990,275728,357238,177736,87121,603353,192734,582451,152710,840245,520643,340490,997523,465499,401705,176107,932787,789001,759091,150895,128046,852672,350988,911619,632196,771297,569077,866441,1041845,455900,910966,725168,607681,104187,271862,456951,459604,140288,551347,399817,746616,1027280,921543,806863,208088,1042762,907442,741469,678362,751063,388230,487585,874088,781999,25836,866948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001922s ]