SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419993 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419993 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167942,62406,6899,905968,328698,173898,72825,96219,685673,685249,999691,262120,211708,647989,271853,258893,18963,158056,349150,419095,135404,1006172,399722,906075,109576,409623,178678,513610,998749,364709,923144,488295,75397,831327,207979,441876,952260,823975,1023597,179944,839156,338565,710189,278927,758240,201207,980499,62640,780056,804220,186655,649846,557906,708693,845148,394534,709707,1038027,670256,127588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003744s ]