SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034180 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034180 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840407,1029907,313088,1014814,112431,384032,514629,747162,964697,938616,102907,64338,749170,122502,433323,529830,767163,410417,118304,910067,509404,940561,612671,259534,667729,574873,204593,236422,536989,795825,355469,475896,430180,1065,927417,195119,495285,44108,366308,19778,385851,568229,740003,298349,411068,349733,945720,439733,918668,248580,386664,659064,618145,444049,503278,785132,527315,535349,497575,941319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001754s ]