SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520206 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520206 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94673,994314,774039,317437,18043,874409,396546,1013418,757557,163088,2650,520822,115856,286702,249926,736334,535384,103012,149015,386291,643483,324021,840279,707610,269067,45698,431615,1030423,512183,231740,567135,591934,669424,703980,15076,324945,262443,216178,329174,638824,496685,272862,752820,36128,285765,76519,627314,54666,1037277,1004560,318046,987071,311486,235593,740403,578041,706799,575132,815045,152992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000933s ]