SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592513 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592513 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333781,274949,355042,636871,73807,352249,625083,334410,294111,545047,600108,151966,118681,797402,716353,90005,976980,5165,101375,184832,741480,803673,944050,226796,141307,104083,512464,925469,709225,386722,393934,1016660,327282,725357,857632,540027,1010263,577288,513588,60001,979844,304383,923493,927895,232444,271236,495453,1013030,253545,541439,245052,770495,117132,434378,248625,849143,942562,792410,505145,69564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]