SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544383 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544383 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017853,557364,260438,307102,788992,1036535,141018,799426,765186,677980,735700,48447,109456,690773,195263,754803,568101,1024552,500987,495353,709642,1021338,244096,356313,230179,889368,318389,393840,931396,225956,199356,810572,380803,225285,998268,431230,746260,609847,168997,179458,99182,771252,929932,956843,261802,397227,208574,840999,293875,690437,546990,928436,421988,983254,646790,933399,790511,365391,31570,896328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]