SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395037 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395037 [ RunTime:0.003471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607816,701669,327160,884963,147953,584455,100301,217725,181668,553660,118915,929327,167449,702377,303778,140738,944172,211031,595666,1033272,111002,972899,340009,460165,190958,747154,934464,873549,608007,129549,117698,96041,445192,411139,687729,631071,375946,882096,549171,965009,142451,417552,619563,201572,705984,329662,810890,920539,695870,812432,43995,360616,853726,908770,718490,362464,126705,1003701,370972,285680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]