SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528806 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528806 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628752,484869,664790,366431,901199,308436,494213,182487,462310,13924,997062,331555,102974,260714,36854,207099,89684,235199,925313,66332,783781,673087,632967,314363,492504,480213,1031405,794831,420667,342262,1002020,81535,165717,161589,101874,989351,925358,507913,334326,734361,394261,783250,152155,835693,315542,516313,941891,526836,795299,748699,334301,196617,543596,438962,645455,79900,550180,375170,375274,728768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]