SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466815 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466815 [ RunTime:0.003331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134687,258792,530837,769911,183527,839447,664460,712132,948351,716767,500891,485534,538083,134315,66361,776396,1047247,513455,324227,366209,221169,1028680,569209,832798,594329,518318,470791,314559,410785,416038,342138,137638,407611,524021,309465,133882,362670,411188,522062,832598,863410,522802,23684,127140,491080,73930,785228,260545,305901,304074,469906,294784,790285,328601,86955,280205,95903,856056,914265,385758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]