SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002675s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518856 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518856 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968689,440333,470477,967314,911608,827391,663614,653434,221481,511013,906028,649009,336884,427244,885327,278744,140388,901170,504093,759185,508139,931703,675652,740661,937795,332486,175725,195055,699017,249317,795197,163682,269790,732064,411514,534302,182670,48591,277249,716648,329177,769924,780605,952960,56945,360509,386063,331009,375373,522086,419337,257108,85067,687350,418095,113084,858613,755733,796619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]