SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464001 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464001 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603363,651889,481741,750213,197682,183681,3882,19588,612855,142455,643278,107474,784951,371037,820978,237573,292636,48318,616488,405615,656130,592263,274922,94802,121317,462573,851379,473800,830485,187942,700408,224248,270406,407597,67580,549069,453136,350352,1023038,815808,173031,336560,700735,235043,415853,237436,118278,33685,810462,473416,294764,970809,644476,503653,28865,900469,157898,365822,449036,404808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]