SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003486 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003486 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54558,738744,206879,4442,1022803,38096,571486,648368,279075,155664,292973,725349,246033,852679,517176,16102,353704,519841,345307,322840,348560,993700,160760,605916,400989,458163,683127,955769,326342,828062,861473,399456,858020,840101,1041996,44524,5776,470955,756598,286429,141371,976230,714082,1019900,250374,800946,644031,206276,790708,722582,497844,370381,639808,105908,886777,112956,730612,649498,343202,250658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000938s ]