SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509916 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509916 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664551,505736,110545,649621,298907,195142,275717,130881,620089,551640,583165,413773,370424,210521,49862,211475,850180,609780,522043,841816,744936,961235,246101,548727,688049,290814,731242,499545,524987,124211,368097,758949,288148,1022306,571520,752594,36802,1034308,783780,325108,299676,133115,458785,949575,412893,996746,1019190,591186,634167,281380,276260,885400,232172,91470,869673,713420,698867,664766,637280,581350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001124s ]