SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540714 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540714 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141753,84555,315940,337902,863998,538939,667108,657576,277077,278122,147629,997468,604604,68215,784087,720652,58529,1001312,186750,854931,584495,351874,610107,450555,416666,32568,401650,278892,901302,870329,484424,204243,130407,149088,813479,437379,640987,377036,757511,541754,125165,245857,846530,532577,871718,281262,356973,32270,56751,492488,745683,406125,891412,167274,732048,1027743,45100,498422,578103,131430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]