SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244993 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244993 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026073,713418,162103,325741,873581,212863,760699,161495,445717,519964,50306,119145,344838,185917,378990,370123,392845,288124,703032,1026114,950021,374773,304010,1031512,652589,151125,827094,825411,692496,483802,422867,309057,283713,231909,829902,631694,825143,998071,371095,168999,237731,1006356,1006187,571132,151015,923741,54665,613698,834227,169776,1032328,205145,55289,994492,729763,208962,989749,927607,68583,496767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]