SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335543 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335543 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701782,804787,12973,524256,723047,878149,643479,65323,207238,884467,463369,549710,888285,434257,780655,873227,512250,977216,1034724,174716,91274,159223,172069,57569,721010,910582,509595,128187,144960,382019,566145,969639,370310,77193,920536,1033334,551250,592942,419296,462095,509961,322925,74366,392642,497983,479808,761499,922087,409256,933679,344083,628630,868444,407235,86508,218275,726207,304350,855704,500543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003699s ]