SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981210 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981210 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381555,460813,141192,462563,135265,401431,344712,213277,448598,745150,169578,41621,931692,142141,509784,229967,640995,538223,613520,49519,784040,1016060,785886,94377,133532,1517,278928,595567,393418,698680,343264,174196,628483,570471,968416,645049,857142,795217,303475,670800,74064,1046190,259191,72482,167450,290994,45636,892326,428190,1011426,508963,409049,126163,559871,913880,835762,974543,809540,751243,520263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]