SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255601 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255601 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841041,914252,162765,298693,261959,988998,822748,141712,373847,241926,311511,142046,822077,375621,370916,961016,963478,285300,337106,633612,343012,1031459,845574,607236,73276,369617,129340,334159,84236,200108,71068,990805,486097,177708,330371,889372,783556,113804,958936,43369,44321,544802,864512,28972,749708,640327,803960,420535,198270,2973,40085,887717,620216,586335,338787,682375,581058,437698,111179,330229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]