SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200503 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200503 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954349,104051,15550,42010,810981,468136,413638,122026,620394,965280,646121,1004367,643019,529861,565723,194191,657792,427821,360059,529249,619527,506444,532703,225036,957390,267198,454582,880540,134690,702038,68442,213448,444394,947391,204427,446358,500093,538706,30956,537907,414965,396098,1006113,41505,189676,625740,201321,553822,900105,639311,30551,693177,646069,751930,1040980,376272,1025625,395378,335695,1005410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]