SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 640511 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 640511 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790044,506241,1040787,190279,148983,283992,965973,211804,20659,190194,6004,526974,947570,796228,840836,15121,1042142,394498,874609,552291,254540,594249,591465,263038,321147,503025,426071,722940,301826,203688,538952,284550,89035,286586,137775,282813,962647,422867,65241,244637,244051,709108,439584,34568,1031433,145845,642772,929765,108533,720976,1048628,407285,804847,796342,160263,671507,994711,783748,587316,973853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 640511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 640511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001850s ]