SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520109 LIMIT 1 [ RunTime:0.000740s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520109 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573139,539975,872542,516237,36890,960007,649766,459665,235120,734321,704956,455972,638498,711594,722212,325105,807476,789838,751881,423977,395094,226097,859403,818337,512156,105100,1027553,570832,1008888,948955,587951,710588,832396,336975,733944,22141,112996,373525,1032445,334417,496026,853160,733762,175997,235091,557892,433964,1017710,712212,715082,818152,753087,371450,492824,683140,900809,192005,869102,670606,965367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]