SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515487 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515487 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452691,667666,943568,436291,332050,316853,493733,349281,745969,571575,368380,701221,167700,45347,869504,758815,332559,52646,275041,629752,818146,234060,250278,684608,263836,605475,763754,239549,405114,91100,805785,325281,288661,92768,96742,441370,358813,511951,866304,930247,21422,84526,538240,654115,669772,195556,858903,449707,811069,289948,647515,156204,738106,221586,297560,424832,973598,486558,915868,419781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]