SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458233 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458233 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111334,382430,105858,279121,933820,34963,173963,50746,1022581,168512,1031720,486750,928851,380936,893513,987001,650921,543109,10475,271709,25898,445069,65905,266500,345236,402439,498817,314378,488892,528137,1047380,707724,725842,672872,625403,736043,588461,101419,355371,789044,349546,482382,984071,109364,623060,787099,297671,150085,191215,160876,278382,515253,169697,337441,500710,166297,1016564,95183,308980,697833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458233 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458233 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]