SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376780 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376780 [ RunTime:0.003292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281744,317678,591615,634108,840356,200646,269242,368819,809100,805138,317982,467035,636972,877254,779483,414765,402507,179490,154635,420312,54717,248455,536864,86198,286970,407111,7727,721734,640797,164197,407998,884076,76117,104607,48560,314336,57060,478614,465805,280149,266721,1037845,388514,607765,845985,300971,910966,131060,65764,577887,431336,334568,180372,856038,788739,704554,859872,558872,568287,124109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]