SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545641 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545641 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367369,1035452,786779,894990,640696,221643,499986,213607,257846,753215,537401,187400,143237,825748,625508,139607,438559,982901,756309,109371,37946,507854,165186,92792,1026633,560013,1007884,680365,763977,529579,526692,346491,120939,44933,698118,809526,799846,751126,466029,1002579,811279,383580,76652,730008,696353,297274,1026023,193475,579520,511951,1025550,397581,202380,117550,81223,241250,458430,29973,596658,156005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]