SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 789040 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 789040 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61384,405229,51435,1012698,315448,754672,761549,1026694,316348,1019035,399178,713777,553436,550896,207345,390716,264682,664988,635881,384978,423527,703178,171771,452505,439396,955986,833387,908005,1045914,329348,234204,820196,216529,779146,818066,416396,1014488,499052,79750,528646,218570,784834,106777,126403,442348,318074,268612,292326,455500,122535,911856,274016,302835,389186,687193,469040,447317,234325,998523,243882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 789040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 789040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]