SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500218 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500218 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340540,363096,429357,93871,97983,794466,181747,379838,590581,523991,93346,234499,578349,304630,27877,24019,907294,199058,540383,43320,269141,953899,440332,938778,585297,232564,982844,509877,876330,820315,425554,497703,594921,655042,788919,129318,165899,69484,458020,667116,766945,893645,447925,1035723,788541,845808,211379,783614,58744,962511,409703,811441,636730,635088,265678,769060,741077,314296,132795,304136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]