SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446957 LIMIT 1 [ RunTime:0.000843s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446957 [ RunTime:0.003983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114856,723041,439699,475179,492599,334406,965758,579551,524564,456607,340942,1027466,495661,758008,340424,986449,399000,259180,832118,513054,181440,1014773,601524,1009529,217133,443957,417592,554635,373105,1021008,251608,675481,919519,49274,285815,198565,483455,194036,1018585,371378,516848,330313,981699,884102,445904,14445,129753,259533,760255,191264,317855,950372,165740,783844,600637,874472,78470,114385,656836,49057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000853s ]