SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023323 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023323 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865949,672264,707023,804562,970583,955315,925111,43362,547638,809326,289963,258774,981309,727373,52889,885576,405488,231961,657038,1026708,918444,591382,628201,112563,234482,406996,491091,587868,402045,828470,839320,140495,563994,444937,851078,272150,945698,938555,980297,889229,159551,817633,46880,199513,685879,653323,1005469,596878,724106,504512,180665,681513,349382,826290,985094,56414,734533,1013981,130754,342089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]