SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004971s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145057 LIMIT 1 [ RunTime:0.001501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145057 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155945,312526,4921,349513,441329,419532,644505,245052,718846,684199,218442,166128,615219,1008727,858533,906867,568061,621050,288985,275489,480112,125793,288502,911786,986945,248673,384084,579251,650489,677837,647037,586482,173635,839027,245854,640944,25084,182857,600076,220734,345511,197304,136286,468316,1007141,475261,585214,1005879,768644,479874,371839,515812,863694,542765,450784,760554,90086,398886,882230,215100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001639s ]