SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546076 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546076 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716794,847385,116703,30578,429571,72204,1000689,562986,407839,691692,754739,721959,894316,1022402,918517,586380,971222,743759,473168,766037,187740,746318,320045,703264,279274,542070,924263,179105,659825,55359,1003108,806232,1019471,692880,114051,13971,80517,499289,239690,392809,968946,580718,668713,738983,414660,1023146,67129,183102,18414,854488,920699,658284,213378,400240,493069,826215,394069,744910,1002953,999337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]