SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104157 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104157 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321948,191266,282356,468391,128121,928952,233636,914107,498984,262163,513861,541818,658895,735986,1007917,170597,549078,827454,671372,848328,1003657,949992,836439,1038220,857212,535894,880092,178155,964282,715688,658681,663776,589398,824118,571030,288692,625476,210370,123244,530073,318916,63255,861313,813368,367212,1002995,442822,294007,190517,845902,764919,722074,207277,196635,898841,342875,117510,199164,289348,102933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]