SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191981 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191981 [ RunTime:0.002570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001985,903132,562148,631680,932961,194037,782361,426412,324495,169138,404987,229710,30850,1026543,148787,453429,527889,852905,1040913,248170,692204,927351,330015,280629,958444,840496,759061,428813,727992,155201,344422,377290,359542,386004,539386,1029028,492175,420655,972332,779862,597881,955297,131004,294908,798086,463435,1032777,446616,53421,660902,219146,443953,55551,956148,300470,485534,141865,95923,687700,778141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000851s ]