SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291668 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291668 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521008,455053,565962,376742,344777,841768,567715,17160,904915,415243,981962,728658,258256,920578,66058,85034,189663,676854,730638,457303,182230,828574,634343,53762,679453,460509,64931,1008361,860800,568648,271634,200633,717832,233974,247949,182724,294215,451522,450385,591051,203258,71800,607547,326444,436101,724452,977045,576462,641390,853411,930500,285232,477694,204156,272168,105964,79600,373050,237490,690324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]