SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022916 LIMIT 1 [ RunTime:0.000651s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022916 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214901,536249,33794,349787,858033,469038,959307,300907,370824,663181,572679,655212,961767,736534,193833,463501,677676,264898,235409,456150,172575,447089,420361,192963,162193,396371,206585,1015205,459217,961487,471641,381311,1044700,504602,357452,519351,22587,1020159,407653,444814,146579,622987,560023,1035859,944978,180325,627518,666981,903534,930383,1011093,5798,103929,605062,922363,770091,323702,484387,720404,92366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]