SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294679 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294679 [ RunTime:0.002048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749538,897305,424363,577745,70844,119934,550865,116290,1016700,794714,526885,138210,956170,255779,1022856,701380,1018420,178797,500753,299507,1027412,433310,680477,553431,983114,191507,661855,9105,51819,360364,748756,610589,989778,142482,459179,393985,498487,835275,212666,212356,186886,35912,119126,788178,104804,206036,450897,585871,748880,88690,977937,440026,162538,1007077,710630,375148,104084,379877,889513,921916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]