SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551113 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551113 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935332,660078,677952,1037818,315385,158967,323593,29863,83349,972568,191661,467842,485507,283031,803425,680593,166090,233136,1014888,915693,178098,873684,459379,270802,972452,978029,867102,907146,535812,679788,203192,20768,465729,199391,313109,796801,483871,467187,252596,7976,584438,805993,141880,1001744,362629,453850,248043,872397,347719,204535,701757,29539,98684,592762,744870,450390,303740,593444,785807,78126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]