SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40261 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40261 [ RunTime:0.002578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356791,855895,136994,667846,303563,1014964,377326,392603,22034,934333,155155,418246,519306,125871,308347,980224,664009,28109,593049,555517,479586,566273,823474,996755,947830,12919,355491,684238,856851,1039119,82407,334619,148507,915656,163733,905442,430109,287075,741636,670243,249122,429581,646381,218971,498441,41098,731292,267160,153664,375786,319235,362681,877019,198455,877662,1041575,49272,782310,340237,523548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]