SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435447 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435447 [ RunTime:0.002482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732756,1026437,402758,707796,870822,120140,177319,591484,144496,138751,455798,689159,543358,583666,380467,258610,580474,354544,216476,254841,241030,418359,629184,921065,382607,81368,563055,644155,763760,114490,450344,44740,946140,482004,691725,839591,414812,282250,991828,615341,669613,696910,905308,845023,834286,79180,742681,703992,664605,238772,929930,1044493,328690,422409,333533,947811,984994,380103,270230,691749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]