SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012257 LIMIT 1 [ RunTime:0.000862s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012257 [ RunTime:0.002957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101268,570646,29980,69357,211463,603084,38399,316980,576811,955490,65362,803631,906454,498118,415051,464127,743478,412177,402629,111666,407160,779960,760468,419297,159412,701342,424963,108389,953055,792943,1010081,714424,1011961,952000,270817,960463,437425,781455,865299,814277,647842,581459,440501,1010664,823924,10697,215957,692942,712796,311607,805002,429702,991056,140114,218111,489836,760574,11107,820534,154794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]