SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802189 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802189 [ RunTime:0.003138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798945,3964,544734,180515,156887,412697,171142,215231,993967,892161,514271,802256,923360,593623,126996,329361,329073,747402,1015769,1018947,305880,912347,723046,189610,829172,10487,513381,565512,183853,180828,541057,260843,370646,46151,437704,244090,146058,352781,995572,920555,876512,891410,962407,122829,73323,714124,961244,189181,60865,838687,729829,569749,126171,1011004,263290,166840,149075,409672,531610,555036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]