SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545283 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545283 [ RunTime:0.003100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590144,358733,730065,962817,1021502,978160,625440,534441,176371,651573,969308,245999,863978,429423,32618,31708,64080,566217,289089,411808,449470,692369,177298,586474,922999,782473,1004130,575120,508618,659548,901172,903042,286047,245928,918055,126119,791255,518905,1001508,230186,852549,835602,709538,461450,573582,268325,190252,488524,54225,142727,755754,494954,987201,228168,910811,83643,551723,15719,124761,1017018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]