SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508075 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508075 [ RunTime:0.003468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150504,449275,632126,1043845,906562,86376,1025794,653011,881123,480851,322596,294797,647780,446629,81666,414913,478081,45577,485130,533277,494056,1023459,724706,620064,714466,403960,934987,837469,311672,965004,781653,871442,9427,504780,608402,47085,227369,531926,202913,652081,546645,706698,577843,1028964,412235,77643,943617,252779,901576,169258,123379,770222,913347,35388,336583,102099,809485,713758,218490,1000715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001115s ]