SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342751 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342751 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61093,947128,641401,769970,866123,900459,1039665,840144,600730,601431,906934,230216,1022286,271777,849840,358261,876142,723802,530174,872563,361017,730401,829462,462819,10425,10972,615970,225819,598888,394458,21282,907040,420957,283438,684310,819659,36509,856259,189605,200346,38468,107944,238105,217758,1038413,146738,28075,548192,250740,794209,277205,841595,34823,453105,460801,278777,257714,611786,632567,387804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]