SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002747s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036645 LIMIT 1 [ RunTime:0.002687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036645 [ RunTime:0.004676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005208,19414,782650,241394,910417,845590,353123,294428,263136,880100,381307,356468,126551,49667,40401,483486,782882,479887,224670,499684,712297,942050,195308,77917,645668,34407,489923,383353,819119,532314,418014,969423,936558,268989,514147,998234,612174,739172,673032,870611,361859,649929,741194,205748,338695,380741,25663,206291,159193,25919,601566,33803,220281,886659,192030,15891,779654,720516,972588,24511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001139s ]