SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102517 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102517 [ RunTime:0.001369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644601,477950,612410,611086,961542,75719,24161,172638,877801,78356,40071,749250,467230,285114,926411,895047,523267,203678,773941,347417,236594,525217,36222,350711,702496,947537,304461,28499,166848,690416,689411,529625,380094,84583,304330,782050,505378,194602,288162,642695,712712,266899,750768,590164,483226,112619,178843,443454,86185,130489,116109,878638,1016606,326772,1029568,637018,564809,182836,227026,254709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]