SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485861 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485861 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972857,250121,1023747,1008694,835154,342723,118928,539748,646621,985062,320774,268075,1023554,57084,799465,31900,994302,1040694,275230,637962,836284,876292,62907,304059,865141,1011341,94841,492836,1048444,328408,453854,193912,274543,337400,637293,729387,725075,33100,113730,940305,895656,871618,22800,460732,796252,406720,177814,877680,341310,676361,404446,177115,996145,906101,107164,765844,829839,819195,78940,148701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]