SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513113 LIMIT 1 [ RunTime:0.001282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513113 [ RunTime:0.003173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218321,833027,575249,23345,218473,614032,446834,482827,579151,96749,477567,1029492,340221,710744,422852,608868,168411,356913,39532,784445,1002805,193699,936893,477947,446106,4867,956326,388145,876856,785071,705368,913490,520325,809462,880069,967222,10489,133917,919021,215711,111542,337616,400096,700473,55285,629651,803743,74467,965111,226791,394174,169125,15467,735791,205269,684172,809523,216405,757779,975161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001214s ]