SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418143 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418143 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305714,756700,1041837,606908,647526,212382,430580,277812,24381,334400,1039571,363946,563129,1579,114638,792928,385614,865289,600498,488225,813001,14433,743073,239981,568321,721977,491886,738716,922171,552739,624912,626359,647598,327494,816580,912848,411605,233737,526771,1014825,491407,347616,583123,946763,929110,474748,25679,680822,515256,950163,967908,923089,667277,947817,73727,975374,128959,2168,820752,728722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]