SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002781s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428521 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428521 [ RunTime:0.002238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703385,280955,279580,42607,650829,804108,257169,525994,188756,402608,905629,405485,384393,125771,191317,184150,223297,776422,768138,684260,925831,1031663,794369,701957,44089,720552,241494,914852,996255,533365,836191,386372,232883,616316,281235,441303,567448,894809,774695,83663,385674,160382,174859,357940,557315,307773,756520,722515,112956,861437,39144,23233,1013801,256606,117230,20958,456415,996271,458052,501449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]