SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000897s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509216 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509216 [ RunTime:0.002028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444931,745022,402622,49373,237274,932233,917820,1032669,817822,50464,772400,47071,276825,160490,779285,19214,478662,908957,908318,731063,536304,578311,378973,489003,333693,467010,334666,862116,358916,747693,443673,759747,664585,766406,274415,277092,1031474,774523,120919,982768,180987,768798,342735,59647,16305,550727,356874,1047203,36517,470518,828288,763211,719650,35626,849690,103930,997706,689816,742578,895218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]