SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430022 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430022 [ RunTime:0.003735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547499,261774,64927,101323,926048,821072,819670,592511,974011,769686,867452,176524,936966,341304,752728,455493,396006,878727,499401,750556,730729,297362,72377,873109,655236,174618,245635,121434,154182,711112,691161,391177,132253,714987,543382,132493,836219,234904,545125,618580,221865,88950,700061,886237,486937,680593,542043,31018,945677,499179,144581,1025212,822706,859727,823652,571270,949207,449118,880207,601243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]