SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310021 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310021 [ RunTime:0.001430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62756,16389,474186,451822,791247,259301,520695,234209,941653,391214,313180,571023,944259,321925,348691,30604,936212,281163,1011055,774256,568060,411824,826043,993606,374814,390387,2816,158739,438549,693520,261608,257073,995940,2612,225266,976265,662168,721749,769376,456737,560653,765600,834858,678626,387779,657101,998476,1016683,622737,534439,756359,655769,94928,54227,388359,531329,183369,466480,380633,160152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]