SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41841 LIMIT 1 [ RunTime:0.000590s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41841 [ RunTime:0.002860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470828,689213,360771,840199,542125,618258,303773,378923,390261,1026227,19813,420401,524824,749999,941804,672538,96889,665010,557215,396708,464619,352023,826482,894188,479937,923416,394707,222499,229201,355729,37258,947314,607305,369664,953863,867450,31746,445569,899742,84548,656798,513812,582377,407438,924326,753627,745267,637595,821630,899589,244417,653675,869927,360946,682208,300598,59100,360666,801097,281018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002906s ]