SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005515s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003330 LIMIT 1 [ RunTime:0.004107s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003330 [ RunTime:0.003472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916240,799661,740993,999404,52339,1026303,48744,363929,8345,878167,551982,182370,878338,740600,875040,50487,845084,991698,1013784,395195,587211,230205,732498,909004,428017,797181,632205,243525,34249,558412,220634,723232,713004,284299,787949,243460,502168,381793,795819,396723,840308,741210,827297,532410,875637,736135,111341,25588,1027319,397437,1037071,232656,789337,39135,220447,534044,782062,41303,1007879,10856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]