SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451183 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451183 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94701,427177,706364,133484,878537,855999,402001,390518,645020,847297,112112,725347,590024,204831,240732,383135,355172,745455,298311,419302,89317,586698,723295,83997,236207,930615,547586,399293,189142,97471,191217,659747,373851,854150,813092,167767,88463,310511,291431,302248,692264,842808,927566,568541,957405,851450,720551,239856,560098,634688,684741,815151,358525,71880,997747,610188,10726,815420,496912,185346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]