SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406989 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406989 [ RunTime:0.001461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917041,118887,260483,190040,28626,450291,133627,199283,716065,919121,334301,984829,370868,107804,140600,998743,999564,537911,925153,300423,820103,698453,398627,966177,828687,139249,134893,413692,52722,161483,322799,898211,850560,449588,719651,611272,976070,598766,172213,398926,232343,170886,471545,730438,174029,218540,72924,1017807,235469,905150,989919,751322,377391,1018071,261970,8948,974284,291577,519094,917517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]