SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193803 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193803 [ RunTime:0.003037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945474,802044,361855,591923,817785,633321,709745,31913,687961,352442,222764,568589,417472,800134,269188,592528,19408,746104,444225,315481,612303,235655,488731,655233,546373,56877,832399,776583,538840,21851,354276,1016759,472952,520348,44269,721948,145272,80058,360817,821325,864379,430882,707593,669900,58132,146871,59519,401486,18782,554016,186501,376764,211631,1031651,136696,544340,1000272,513515,663774,1010340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]