SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 123341 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 123341 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418385,639667,45982,321196,381966,498866,374175,610844,452570,683311,1019460,197082,680229,676566,721873,484315,970594,727868,510066,932857,616386,530934,586129,448878,31459,267064,488219,275933,198378,431388,435529,145593,298660,111256,426680,979598,215861,631434,712918,232314,280376,256639,286212,34829,663860,476575,503904,728486,43496,59457,458454,526848,662223,356493,479933,550689,854809,875553,880170,540466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 123341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 123341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]